﻿CREATE ROLE [ESBBrowseAndManageFaults]
    AUTHORIZATION [dbo];
GO

GRANT SELECT ON [Alert] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [Alert] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [Alert] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [Alert] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [AlertCondition] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [AlertCondition] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [AlertCondition] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [AlertCondition] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [AlertEmail] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [AlertEmail] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [AlertEmail] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [AlertEmail] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [AlertHistory] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [AlertHistory] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [AlertHistory] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [AlertHistory] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [AlertSubscription] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [AlertSubscription] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [AlertSubscription] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [AlertSubscription] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [AlertSubscriptionHistory] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [AlertSubscriptionHistory] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [AlertSubscriptionHistory] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [AlertSubscriptionHistory] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [AuditLog] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [AuditLog] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [AuditLog] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [AuditLog] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [AuditLogMessageData] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [AuditLogMessageData] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [AuditLogMessageData] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [AuditLogMessageData] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [Batch] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [Batch] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [Batch] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [Batch] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [Configuration] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [Configuration] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [Configuration] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [Configuration] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [ContextProperty] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [ContextProperty] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [ContextProperty] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [ContextProperty] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [Fault] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [Fault] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [Fault] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [Fault] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [Message] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [Message] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [Message] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [Message] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [MessageBatch] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [MessageBatch] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [MessageBatch] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [MessageBatch] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [MessageData] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [MessageData] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [MessageData] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [MessageData] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [ProcessedFault] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [ProcessedFault] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [ProcessedFault] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [ProcessedFault] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [UserApplication] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [UserApplication] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [UserApplication] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [UserApplication] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON [UserSetting] TO [ESBBrowseAndManageFaults]
GO

GRANT INSERT ON [UserSetting] TO [ESBBrowseAndManageFaults]
GO

GRANT UPDATE ON [UserSetting] TO [ESBBrowseAndManageFaults]
GO

GRANT DELETE ON [UserSetting] TO [ESBBrowseAndManageFaults]
GO

GRANT SELECT ON dbo.vw_AggregatedFaults TO ESBBrowseAndManageFaults
GO

GRANT SELECT ON dbo.vw_UserApplication TO ESBBrowseAndManageFaults
GO
